Photo by Martin Vorel on libreshot
Nesta tarefa vocês terão a oportunidade de criar um Dashboard responsivo a partir dos datasets a seguir:
Global Superstore Orders 2016.xlsxGlobal Superstore Returns 2016.csvUsaremos os pacotes (bibliotecas) tidyverse e
flexdashboard de forma obrigatória. Outras
bibliotecas podem se instaladas por cada equipe, de acordo com as
necessidades específicas do dashboard.
Os dados incluem as vendas fictícias de uma grande loja, chamada
Global SuperStore, incluindo ordem de pedido, data de
compra, data de expedição, nome do cliente, categoria do produto, valor
da venda e prioridade, dentre outros.
A seguir, mostram-se as primeiras linhas do dataset
Global Superstore Orders 2016.xlsx.
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Postal Code | City | State | Country | Region | Market | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | Shipping Cost | Order Priority |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40098 | CA-2014-AB10015140-41954 | 2014-11-11 | 2014-11-13 | First Class | AB-100151402 | Aaron Bergman | Consumer | 73120 | Oklahoma City | Oklahoma | United States | Central US | USCA | TEC-PH-5816 | Technology | Phones | Samsung Convoy 3 | 221.980 | 2 | 0.0 | 62.1544 | 40.77 | High |
| 26341 | IN-2014-JR162107-41675 | 2014-02-05 | 2014-02-07 | Second Class | JR-162107 | Justin Ritter | Corporate | NA | Wollongong | New South Wales | Australia | Oceania | Asia Pacific | FUR-CH-5379 | Furniture | Chairs | Novimex Executive Leather Armchair, Black | 3709.395 | 9 | 0.1 | -288.7650 | 923.63 | Critical |
| 25330 | IN-2014-CR127307-41929 | 2014-10-17 | 2014-10-18 | First Class | CR-127307 | Craig Reiter | Consumer | NA | Brisbane | Queensland | Australia | Oceania | Asia Pacific | TEC-PH-5356 | Technology | Phones | Nokia Smart Phone, with Caller ID | 5175.171 | 9 | 0.1 | 919.9710 | 915.49 | Medium |
| 13524 | ES-2014-KM1637548-41667 | 2014-01-28 | 2014-01-30 | First Class | KM-1637548 | Katherine Murray | Home Office | NA | Berlin | Berlin | Germany | Western Europe | Europe | TEC-PH-5267 | Technology | Phones | Motorola Smart Phone, Cordless | 2892.510 | 5 | 0.1 | -96.5400 | 910.16 | Medium |
| 47221 | SG-2014-RH9495111-41948 | 2014-11-05 | 2014-11-06 | Same Day | RH-9495111 | Rick Hansen | Consumer | NA | Dakar | Dakar | Senegal | Western Africa | Africa | TEC-CO-6011 | Technology | Copiers | Sharp Wireless Fax, High-Speed | 2832.960 | 8 | 0.0 | 311.5200 | 903.04 | Critical |
| 22732 | IN-2014-JM156557-41818 | 2014-06-28 | 2014-07-01 | Second Class | JM-156557 | Jim Mitchum | Corporate | NA | Sydney | New South Wales | Australia | Oceania | Asia Pacific | TEC-PH-5842 | Technology | Phones | Samsung Smart Phone, with Caller ID | 2862.675 | 5 | 0.1 | 763.2750 | 897.35 | Critical |
E as primeiras linhas do dataset
Global Superstore Returns 2016.csv :
| Returned | Order ID | Region |
|---|---|---|
| Yes | CA-2012-SA20830140-41210 | Central US |
| Yes | IN-2012-PB19210127-41259 | Eastern Asia |
| Yes | CA-2012-SC20095140-41174 | Central US |
| Yes | IN-2015-JH158207-42140 | Oceania |
| Yes | IN-2014-LC168857-41747 | Oceania |
| Yes | ID-2013-AB1001527-41439 | Eastern Asia |
Você pode baixar os dados